package com.xjtu.mapper;

import com.github.pagehelper.Page;
import com.xjtu.entity.Assessment;
import com.xjtu.entity.CapabilityAssessment;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
* @author 2070929887
* @description 针对表【capability_assessment(能力评估表)】的数据库操作Mapper
* @createDate 2023-11-12 14:47:30
* @Entity com.xjtu.mapper.CapabilityAssessment
*/
public interface CapabilityAssessmentMapper {

    int deleteByPrimaryKey(Long id);

    int insert(CapabilityAssessment record);

    int insertSelective(CapabilityAssessment record);

    CapabilityAssessment selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(CapabilityAssessment record);

    int updateByPrimaryKey(CapabilityAssessment record);

    @Select("select * from capability_assessment where elderly_id = #{elderlyId}")
    List<CapabilityAssessment> queryByElderlyId(Integer elderlyId);

    Page<CapabilityAssessment> pageQuery(String name);
}
